package cn.yuanqiao.archive.storeRoom.mapper;

import cn.yuanqiao.common.domain.YqField;
import cn.yuanqiao.common.domain.YqTable;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface InitializationMapper {

    List<String> getAllTablesList(@Param("code") String code);

    String getAllTables(@Param("code") String code);

    List<YqTable> getTableList();

    String getFieldList(@Param("tableName") String tableName, @Param("sqluser")String sqluser);

    List<YqField> getFieldListByTableId(@Param("tableId") String tableId);


    String getSqlUser();

    List<YqField> getFields(@Param("tableId") Long tableId);

    void createTable(@Param("sql") String sql);

    int insertYqtable(@Param("tableName")String tableName, @Param("tableCaption") String tableCaption, @Param("description") String description, @Param("type") int type);
}
